Transactions Property (Remote Data)

       

Returns a value that indicates whether an object supports the recording of a series of changes that can later be rolled back (undone) or committed (saved).

Syntax

object.Transactions

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The Transactions property return values are:

Value Description
True The object supports transactions.
False The object doesn't support transactions.

Remarks

Check the Transactions property before using the BeginTrans method to make sure that transactions are supported. When Transactions is False, using the BeginTrans, CommitTrans, or RollbackTrans method has no effect.

The Transactions property calls the ODBC SQLGetInfo function to determine if the ODBC driver is capable of supporting transactions, not if the current result set is updatable. You can always call the BeginTrans method on the rdoConnection object if the Transactions property is True — even for read-only rdoResultset objects.